Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$BUFFERED_PUBLISHERS

`V$BUFFERED_PUBLISHERS` displays information about all buffered publishers in the instance. There is one row per queue per sender. The values are reset to zero when the database (or instance in a Real Application Clusters (RAC ) environment) restarts.

Column | Datatype | Description
--- | --- | ---
`QUEUE_ID` | `NUMBER` | Identifier for the queue
`QUEUE_SCHEMA` | `VARCHAR2(30)` | Owner of the queue
`QUEUE_NAME` | `VARCHAR2(30)` | Name of the queue
`SENDER_NAME` | `VARCHAR2(30)` | Name of the agent enqueuing the message (the Streams name assigned for a capture process)
`SENDER_ADDRESS` | `VARCHAR2(1024)` | Queue name and database name of the source (last propagating) queue; database name is not specified if the source queue is in the local database
`SENDER_PROTOCOL` | `NUMBER` | Protocol used by the sender's address
`NUM_MSGS` | `NUMBER` | Current number of messages that have yet to be dequeued from the buffer queue
`CNUM_MSGS` | `NUMBER` | Cumulative total number of messages enqueued into the buffered queue since the database last started (comparable to `V$STREAMS_CAPTURE` total_enqueued_messages
`LAST_ENQUEUED_MSG` | `NUMBER` | Most recently enqueued message identifier
`UNBROWSED_MSGS` | `NUMBER` | The count of messages that have been enqueued, but now browsed
`OVERSPILLED_MSGS` | `NUMBER` | The count of messages that have been spilled, but not browsed
`MEMORY_USAGE` | `NUMBER` | The percentage of the streams pool that is being used (or 0 if there is no streams pool)
`PUBLISHER_STATE` | `VARCHAR2(59)` | State of the publisher. Possible values are: PUBLISHING MESSAGES (normal) IN FLOW CONTROL: TOO MANY UNBROWSED MESSAGES IN FLOW CONTROL: OVERSPILLED MESSAGES IN FLOW CONTROL: INSUFFICIENT MEMORY AND UNBROWSED MESSAGES